package com.gold.persist;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.gold.model.User;

public interface UserMapper {
    int deleteByPrimaryKey(Integer uId);

    int insert(User record);

    int insertSelective(User record);

    User selectByPrimaryKey(Integer uId);

    int updateByPrimaryKeySelective(User record);

    int updateByPrimaryKey(User record);
    
    @Select("select u_id uId, u_name uName, u_password uPassword, u_memo uMemo, s_id sId from user where u_name=#{name} and u_password=#{password}")
    User selectByName(@Param("name")String name,@Param("password")String password);
}